from openpyxl import load_workbook
workbook = load_workbook('F:\\python\\第5章\\汽车备案信息.xlsx')
worksheet = workbook['汽车备案信息']
worksheet.freeze_panes = 'B2'
workbook.save('F:\\python\\第5章\\汽车备案信息1.xlsx')
